The Business Master (3rd Edition)

home *** CD-ROM | disk | FTP | other *** search

/ The Business Master (3rd Edition) / The Business Master (3rd Edition).iso / files / busition / dayoups / ups.exe / DAYOUPS.DOC < prev next >

Wrap

Text File | 1992-11-25 | 288.4 KB | 3,781 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ ║ ║ ║ ║ ███▄███████░ ███░ ███░ ███░ █████████░ ║ ║ ███████████░ █████░ ███░ ███░ ███████████░ ║ ║ ███░ ███░ ███░███░ ███░ ███░ ███░ ███░ ║ ║ ███░ ███░ ███░ ███░ ███░███░ ███░ ███░ ║ ║ ███░ ███░ ███░ ███░ █████░ ███░ ███░ ║ ║ ███░ ███░ █████████████░ ███░ ███░ ███░ ║ ║ ███░ ███░ █████████████░ ███░ ███░ ███░ ║ ║ ███████████░ ███░ ███░ ███░ ███████████░ ║ ║ ██▀████████░ ███░ ███░ ███░ █████████░ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ██████░ ██████░ ██████░████████████░ ██████████████░ ║ ║ ██████░ ██████░ ███████████████████░ ██████████████░ ║ ║ ██████░ ██████░ ██████░ ██████░ ██████░ ║ ║ ██████░ ██████░ ██████░ ██████░ ██████░ ║ ║ ██████░ ██████░ ██████░ ██████░ █████████████░ ║ ║ ██████░ ██████░ ███████████████████░ █████████████░ ║ ║ ██████░ ██████░ ██████░████████████░ ██████░ ║ ║ ██████░ ██████░ ██████░ ██████░ ║ ║ ██████░ ██████░ ██████░ ██████░ ║ ║ ███████████████░ ██████░ █████████████░ ║ ║ █████████████░ ██████░ █████████████░ ║ ║ ║ ║ ║ ║ UPS MANIFEST & RATES ║ ║ VERSION 2.0+ ║ ║ ║ ║ Copyright (c) 1992, TJS LAB Inc. ║ ║ 5104 North Orange Blossom Trail, Ste 200, Orlando, FL 32810 ║ ║ ║ ║ ██████ ▀███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ S H N ║ ║ ▀ ██ ▀ ████ ▀▀▀▀▀███████████████████████████▌ O A E ║ ║ ██ ██ ▄███▄ ▀████▀▀ ▀████████████ F R T ║ ║ ██ ██ ██ ▀ ▀▀ ███████████ T D W ║ ║ ██ ▄ ██ ▀███▄ Specializing In ▐█████████▌ W W O ║ ║ ▀███▀ ▄ ██ MicroComputer & Network ██████████ A A R ║ ║ ▀███▀ Solutions & █████*████▌ R R K ║ ║ Applications ▐███████████ E E S ║ ║ ▀██ █ ▀█▄███▄ ┌─┐ ┌─┐ ███████████▌ ║ ║ ██ █▀█ ██ ██ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ Custom: ║ ║ ██ ▄█ █▄ █████ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ Programs ║ ║ ██ ██▄██ ██ ██ ▐▀▌ └───╜ ▐▀▌ ███▄▄███ Reports ║ ║ ████ ▄█ █▄ █▀███▀ █████ ▐▀▌ █████ ▀█████▌ Routines ║ ║ █████ ▀▀▀█ Forms ║ ║ Incorporated █ ║ ║ ▄▄▄▄▀ ║ ╠════════════════════════════════════════════════════════════════════════════╣ ║ Support: (407) 291-3960 Sales: 292-4708 Fax: 295-2171 BBS: 292-4921 ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. ■ SOFTWARE SUPPORT POLICY 1. TJS LAB does not support users of unregistered DAYO products with the exception of installation questions. 2. Support (included with registration) remains in effect for 3 months after date of purchase. 3. Support is available through the following methods: - Phone: (407) 292-4708 - U.S. Mail: TJS LAB, Inc., PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). DAYO UPS, TJS LAB, Inc. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 1...... INTRODUCTION 1...... COPYRIGHT/LICENSE 2...... DISCLAIMER 2...... REQUIREMENTS *** 2...... SETUP 3...... MAIN MENU 3...... PASSWORD/NAME 4...... BROWSE TODAYS UPS MANIFEST 5...... EDIT MANIFEST RECORD - F2 6...... FULL SCREEN EDIT - ALT F2 7...... COMPUTE UPS RATES/CHARGES 8...... COD CHARGES 9...... QUICK CHART - F4 10...... OVERSEAS RATES/ZONES/CHARGES 10...... ADDITIONAL DELIVERY CONFIRMATION RESPONSE OPTIONS 11...... OVERSEAS ZONE CHART 12...... PRINT UPS MANIFEST - ALT M 13...... MANIFEST FIELDS ON REPORT - PART I 13...... EXAMPLE OF MANIFEST REPORT - PART 2 13.1.... IMPORT INVOICES/RECORDS 14...... POST UPS MANIFEST RECORDS 15...... BIG LABEL - ALT 1 15...... STANDARD LABEL - ALT 2 15...... COD LABEL - ALT 3 16...... UPS LABEL - ALT 4 16...... FIND UPS MANIFEST RECORD - F5/F6/F7/F8/F9/F10 17...... BROWSE UPS MANIFEST HISTORY DATABASE 17...... FAST FIND 18...... QUICK CHECK 23...... REPORTS 24...... PRINTER SETUP (DRIVER) 24...... PRINTER DRIVER OPTIONS 25...... CHANGE DEFAULT PRINTER 26...... FULL SCREEN EDIT - F2 26...... PRINTER DRIVER DATABASE FIELD DEFINITIONS 27...... UPS LOCAL ZONE CHART 27...... UPS RATE TABLE 28...... UPS GROUND TRAC RATE TABLE 28...... CANADA GROUND ZONE CHART 28...... CANADA AIR ZONE CHART 29...... CANADA GROUND RATE TABLE 29...... OVERSEAS ZONE CHART 30...... OVERSEAS AIR EXPRESS RATE CHART 30...... OVERSEAS AIR EXPEDITE RATE CHART 31...... REPRINT MANIFEST 32...... UPS EXPANDED REPORT 33...... UPS SUMMARY REPORT 34...... EXAMPLE OF UPS SUMMARY REPORT 34...... CONFIGURATION REPORT DAYO UPS, TJS LAB, Inc. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 35...... EXAMPLE OF CONFIGURATION REPORT 36...... VIEW REPORTS ON SCREEN 37...... REPORT VIEWING SCREEN 38...... CONFIGURATION 38...... LIST OF CONFIGURATION OPTIONS/SETTINGS 39...... COMPANY NAME 39...... COMPANY ADDRESS 39...... COMPANY STATE 39...... COMPANY ZIP 39...... COMPANY TELEPHONE 40...... UPS SHIPPER NUMBER 40...... INVENTORY LOCATION/DIRECTORY 40...... POS (INVOICING) DATABASE LOCATION/DIRECTORY 40.1.... CUSTOMER (AR) DATABASE LOCATION/DIRECTORY 40.1.... CURRENT DIRECTORY DATABASE LOCATION 41...... UPS DEFAULT RATES/OPTIONS 41...... REPORT PRINTER TYPE 41...... REPORT PRINTER PORT 42...... AUTOMATIC DAILY INDEXING 42...... COLOR MONITOR 42...... COLOR INTENSITY 43...... CANADA GROUND ZONES 43...... OVERSEAS ZONES 43...... OVERSEAS AIR EXPRESS RATES 44...... OVERSEAS AIR EXPEDITE RATES 44...... EDIT YOUR LOCAL ZONE CHART 45...... LAST PICKUP NUMBER 45...... BIG LABEL PRINTER PORT 45...... STANDARD LABEL PRINTER PORT 45...... COD LABEL PRINTER PORT 45...... UPS PRINTER PORT 46...... MANIFEST PRINTER PORT 46...... MANIFEST PRINTER TYPE 47...... MISCELLANEOUS ROUTINES 47...... MISC Routines Menu: 48...... APPEND FROM 50...... BROWSE DATABASES 52...... COPY (.DBF) TO 54...... CREATE DATABASE 56...... DELETE RECORDS 57...... ERASE FILE 57...... EXIT TO DOS 58...... INDEX A DATABASE 59...... LIST FIELDS 62...... MODIFY DATABASE 63...... PACK DATABASE 64...... RECALL RECORDS DAYO UPS, TJS LAB, Inc. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 64...... RETURN TO MENU 64...... RUN (DOS COMMAND) 65...... SIMPLE EDITOR 66...... SORT DATABASE 67...... TYPE (PRINT) FILE 68...... ZAP DATABASE 70...... HELP SCREENS 71...... EXPANDED HELP 72...... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 73...... VIEW DOCUMENTATION ONSCREEN 74...... DATABASE LISTING 75...... TJS 'Computer' LAB DAYO UPS, TJS LAB, Inc. Page: 1 ■ INTRODUCTION DAYO UPS Manifest and Rates program provides a system to automate the processing of UPS shipments and looking up zones/rates. It is by default a multiuser system, allowing almost unlimited numbers of users to have the ability to simultaneously invoice using this one program on a PC based LAN/Network. It can however, be run (like all DAYO products) as a 'standalone' application. Some of the DAYO UPS highlights are: Multiuser (ie: Novell) Invoice/POS Interface (used to import records) Data Entry Validation Databases are dBase (tm) compatible HP Laser Special Manifest UPS, COD, Standard Mailing and Big Mailing Labels Rate & Zone charts Other DAYO Products: DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving DAYO Billing & Invoice Invoices, Billing, Sales Reports DAYO AR Accounts Receivable, Sales, Cash Receipts DAYO AP Accounts Payable, Check Writing, Assets DAYO Quotes Sales Quoting System DAYO Price Books Special pricing for your customers as well as a wide range of product catalogs/reports *** And MANY More! ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. An exception to this rule is the making of backup copies of registered software disks. No RESALE of any part of the source codes is authorized without the prior written consent of TJS LAB. TJS LAB retains all rights to DAYO UPS software, documentation, and source codes. Authorization to distribute Demonstration Versions is granted. DAYO UPS, TJS LAB, Inc. Page: 2 ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware, and/or software systems as a result of using DAYO UPS. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk ■ SETUP To setup DAYO UPS, use the SETUP program supplied on the MENU or Update & Conversion diskette, or copy the contents of the DAYO UPS floppy disks into a directory on your hard disk (ie: \DAYOUPS), then 'uncompress' (ie: PKunzip ) there. When running DAYOUPS for the first time, it will create all the database, index, and configuration files it requires for operation. If other DAYO modules are being used, be sure to enter the location of these databases into the DAYO UPS configuration. DAYO UPS, TJS LAB, Inc. Page: 3 ■ MAIN MENU From the main menu screen you have access to the seven (7) main routines in this module. Use the arrow keys or the number 1...7 to select the desired routine to run. Press Esc or select Exit to exit this module. DAYOUPS Version 2.01, Copyright(c) 1992 TJS LAB, Inc, Orlando, Florida ╔════════════════════════════════╗ ┌──[September 1992]──┐ ║ 1 Browse Today's UPS Manifest ║ │S M T W T F S │ ╟────────────────────────────────╢ ├────────────────────┤ ║ 2 Browse Manifest History ║ │ 1 2 3 4 5│ ║ 3 Quick Rate Check ║ │ 6 7 8 9 10 11 12│ ║ 4 Reports ║ │13 14 15 16 17 18 19│ ║ 5 Configuration ║ │20 21 22 23 24 25 26│ ║ 6 Information ║ │27 28 29 30 │ ║ 7 Misc Routines ║ │ │ ╟────────────────────────────────╢ └────────────────────┘ ║ Exit to Dos ║ ╚════════════════════════════════╝ ╔════════════════════════════════════════════════════════════════════════════╗ ║ ██░ ██░ ██▄███░ █████░ █░ █░ ██░ █░ █░ ███░ ████░ ████░ ████░ █████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░██░ █▀▀█░ ██░█░ █░ █░ █░ █░ █░ ║ ║ ██░ ██░ ██████░ █████░ █████░ ████░ ████░ █░ ███░ ███░ ████░ █░ ║ ║ ██░ ██░ ██░ ██░ █░█░█░ █░ █░ █░██░ █░ █░ █░ █░ █░ ║ ║ ██████░ ██░ █████░ █░ █░ █░ █░ █░ █░ ███░ █░ ████░ ████░ █░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PASSWORD/NAME From the main menu, after entering your name or password, you can enter any of the modules. ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: GEORGE MOONILAL ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, Inc. Page: 4 ■ BROWSE TODAYS UPS MANIFEST This is the main routine for creating your UPS manifest. From this routine, you can add, delete, edit, compute charges, compute COD charges, select overseas charges, reset charges, print/post manifest, print big mailing label, print standard mailing label, print COD tag/label, print UPS shipper label, and find a manifest record using numerous methods. ╔════════════════════════════════════════════════════════════════════════════╗ ║ Invoice: 6268 Tracking ID: Zone: 12 ███████ Res ║ ║ Name: GORILLA SYSTEMS Weight: 5 ║ ║ Address: 815 EAST BRYAN ST. Charges: 8.00 ║ ║ COD Amount: 0.00 ║ ║ City: SAPULPA Declared Value: 0.00 ║ ║ State: OK Zip: 74066 Invoice Amount: 0.00 ║ ║ Ground Trac: Y Oversized: Y Call Tag: Y Other: 0.00 ║ ║ Insurance: 0.00 Confirm Delivery: Y Date: 06/23/92 ║ ╟────────────────────[ ■ BROWSE TODAYS UPS MANIFEST ■ ]────────────────────╢ ║ NUMBER INVOICE TRACKINGID NAME ║ ║───────────╥────────────╥──────────────╥────────────────────────────────────║ ║ 0 ║ 6268 ║ ║ GORILLA SYSTEMS ║ ║ 0 ║ 6269 ║ ║ PARROT SYSTEMS ║ ║ 0 ║ 6270 ║ ║ GATORZ SPORT OPTIKS INC. ║ ║ 0 ║ 6271 ║ ║ MICHAEL JACKSON ║ ║ 0 ║ 6272 ║ ║ HERSHEY PASTA GROUP ║ ║ 0 ║ 6273 ║ ║ GEORGE JONES, INC. ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F2 or Alt F2 (Edit) Ctrl N (Add) Ctrl U (Delete) Alt P (Post) Enter (Compute) F3 (COD) F4 (Quick) Alt R (Reset) Alt M (Print) Alt 1(Big Label) Alt 2(Standard Label) Alt 3(COD Label) Alt 4(UPS Label) Find: F5(Invoice) F6(Tracking ID) F7(Name) F8(Number) F9(Zip) F10(Zone) 1/7 DAYO UPS, TJS LAB, Inc. Page: 5 ■ EDIT MANIFEST RECORD - F2 Press F2 to edit the currently highlighted manifest record. All the key fields will be presented to you for editing at the top of the screen. ╔════════════════════════════════════════════════════════════════════════════╗ ║ Invoice: 6268 Tracking ID: Zone: 12 ███████ Res ║ ║ Name: GORILLA SYSTEMS Weight: 5 ║ ║ Address: 815 EAST BRYAN ST. Charges: 8.00 ║ ║ COD Amount: 0.00 ║ ║ City: SAPULPA Declared Value: 0.00 ║ ║ State: OK Zip: 74066 Invoice Amount: 0.00 ║ ║ Ground Trac: Y Oversized: Y Call Tag: Y Other: 0.00 ║ ║ Insurance: 0.00 Confirm Delivery: Y Date: 06/23/92 ║ ╟────────────────────[ ■ BROWSE TODAYS UPS MANIFEST ■ ]────────────────────╢ ║ NUMBER INVOICE TRACKINGID NAME ║ ║───────────╥────────────╥──────────────╥────────────────────────────────────║ ║ 0 ║ 6268 ║ ║ GORILLA SYSTEMS ║ ║ 0 ║ 6268 ║ ║ GORILLA SYSTEMS ║ ║ 0 ║ 6270 ║ ║ GATORZ SPORT OPTIKS INC. ║ ║ 0 ║ 6270 ║ ║ GATORZ SPORT OPTIKS INC. ║ ║ 0 ║ 6271 ║ ║ HERSHEY PASTA GROUP ║ ║ 0 ║ 6271 ║ ║ HERSHEY PASTA GROUP ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F2 or Alt F2 (Edit) Ctrl N (Add) Ctrl U (Delete) Alt P (Post) Enter (Compute) F3 (COD) F4 (Quick) Alt R (Reset) Alt M (Print) Alt 1(Big Label) Alt 2(Standard Label) Alt 3(COD Label) Alt 4(UPS Label) Find: F5(Invoice) F6(Tracking ID) F7(Name) F8(Number) F9(Zip) F10(Zone) 1/7 DAYO UPS, TJS LAB, Inc. Page: 6 ■ FULL SCREEN EDIT - ALT F2 Press Alt F2 to call up a full screen edit of the currently highlighted manifest record. ┌────────────────────[ FULL SCREEN EDIT - TODAYS MANIFEST ]──────────────────┐ │ NUMBER: 0 CALL_TAG: T │ │ INVOICE: 6268 DELIVERY: T │ │ TRACKINGID: SIGNATURE: T │ │ NAME: GORILLA SYSTEMS REQ_REPLY: T │ │ ATTN: CORR_ADDR: T │ │ ADDRESS: 815 EAST BRYAN ST. HAZARDOUS: T │ │ ADDRESS1: INSURANCE: 0.00 │ │ CITY: SAPULPA DATE: 06/23/92 │ │ STATE: OK BY: dsf │ │ ZIP: 74066 │ │ ZONE: 12 │ │ WEIGHT: 5 │ │ CHARGES: 8.00 │ │ OTHER: 0.00 │ │ COD_AMOUNT: 0.00 │ │ DV: 0.00 │ │ AMOUNT: 0.00 │ │ LETTER: F │ │ GRND_TRAC: T │ │ RESIDENT: T │ │ OVERSIZE: T │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO UPS, TJS LAB, Inc. Page: 7 ■ COMPUTE UPS RATES/CHARGES Highlight a manifest record, then press Enter/Return to call up the U.S. rate chart options. The first prompt is to select the standard ground rates or the ground trac option, ie: ╔═══════════════════════════════[ COMPUTE UPS ]══════════════════════════════╗ ║ ║ ║ ║ ║ ║ ║ Select Option -> Standard ║ ║ Ground Trac ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ████░ ████░ █░ █░ █▄██░ █░ █░ █████░ ███░ █░ █░ █▄██░ ███░ ║ ║ █░ █░ █░ ██░██░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ █░ █░ █████░ ████░ █░ █░ █░ ██░ █░ █░ ████░ ███░ ║ ║ █░ █░ █░ █░█░█░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ ████░ ████░ █░ █░ █░ ████░ █░ ███░ ████░ █░ ███░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO UPS, TJS LAB, Inc. Page: 8 The next screen consists of the key fields/options for this manifest record, and all rate/shipping options available, ie: ground (green), residential, 2nd day (blue), and next day (red). ╔══════════════════════════════[ QUICK CHECK ]═══════════════════════════════╗ ║ Standard Date: Tuesday, 23 June 1992 ║ ║ Declared Value: 0.00 Letter?: N ║ ║ C.O.D.?: N Zip Code (1st 3 digits): 740 ║ ║ Call Tag?: Y Weight (in lbs): 5 ║ ║ Delivery Confirmation?: Y State Abbreviation: OK ║ ║ Required For AK, HI & PR ║ ║ ║ ║ Select Method Zone 5, Ground: 3.21 ║ ║ of Shipment -> Zone 5, Residential: 3.66 ║ ║ Zone 12, 2nd Day: 8.00 ║ ║ Zone 22, Next Day Air: 19.25 ║ ║ ║ ║ ║ ║ ║ ║ Charges: 11.35 Delivery, Calltag, Hazardous, Address Co ║ ╟──────────────────────[ Estimated Delivery Schedule ]───────────────────────╢ ║ * Next Day, 1 days ** 2nd Day, 3 days *** Ground, 10 days ║ ║ * ** *** ║ ║06/23 06/24 06/25 06/26 06/27 06/28 06/29 06/30 07/01 07/02 07/03 07/04 07/0║ ║ └─────┴─────┴─────┴─────┴─────┴─────┴─────┴─────┴─────┴─────┴─────┴─────┘ ║ ║Today Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ COD CHARGES Press F3 to bring up a prompt for the COD amount, ie: ╔══════════════════════════════════════════════════════════════════════════╗ ║ Charges: 3.66 Other Charges: 11.35 ║ ║ Invoice Amount: 0.00 Declared Value: 0.00 ║ ║ ║ ║ Enter C.O.D. Amount: 15.01 ║ ║ ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 9 ■ QUICK CHART - F4 Press F4 to compute/view the UPS shipping charges for shipments to any location in the continental U.S., Alaska, Hawaii, Puerto Rico, Canada, and many overseas countries. Note, this is a rate/zone check for the U.S., Canada and all countries overseas that UPS delivers to. ╔══════════════════════════════[ QUICK CHECK ]═══════════════════════════════╗ ║ This routine will compute the UPS shipping charges for shipments to ║ ║ any location in the continental U.S., Alaska, Hawaii, Puerto Rico, ║ ║ Canada, and many overseas countries... ──────────────────────────── ║ ║ Select Destination -> U.S.A. ║ ║ Canada ║ ║ All Others ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ █████░ █░ █░ ███░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ █░ █░ ║ ║ █░ █░ █░ █░ █░ █░ █░██░ █░ █░ █░ █░ █░ █░██░ ║ ║ █░ █░ █░ █░ █░ █░ ███░ █░ ████░ ██░ █░ ███░ ║ ║ █░ █░ █░ █░ █░ █░ █░██░ █░ █░ █░ █░ █░ █░██░ ║ ║ ▀███▀█░ ████░ ███░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ █░ █░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO UPS, TJS LAB, Inc. Page: 10 ■ OVERSEAS RATES/ZONES/CHARGES When computing the overseas rate for a package, you will be initially prompted for the declared value, delivery confirmation, and letter or weight. Note, if you select letter, then no weight need be given. ╔══════════════════════════════[ QUICK CHECK ]═══════════════════════════════╗ ║ This routine will compute the UPS shipping charges for shipments to ║ ║ any location in the continental U.S., Alaska, Hawaii, Puerto Rico, ║ ║ Canada, and many overseas countries... ──────────────────────────── ║ ║ Destination: All Others Today: Sunday, 28 June 1992 ║ ║ Declared Value: 0.00 Letter?: N ║ ║ ║ ║ Weight (in lbs): 5 ║ ║ Delivery Confirmation?: Y ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ █████░ █░ █░ ███░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ █░ █░ ║ ║ █░ █░ █░ █░ █░ █░ █░██░ █░ █░ █░ █░ █░ █░██░ ║ ║ █░ █░ █░ █░ █░ █░ ███░ █░ ████░ ██░ █░ ███░ ║ ║ █░ █░ █░ █░ █░ █░ █░██░ █░ █░ █░ █░ █░ █░██░ ║ ║ ▀███▀█░ ████░ ███░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ █░ █░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) PgDn/PgUp (Save & Continue) ■ ADDITIONAL DELIVERY CONFIRMATION RESPONSE OPTIONS If you select delivery confirmation, you will be prompted to select the 'Signature Required', 'Request Specific Reply Address' or neither option, ie: ╔══[ ADDITIONAL DELIVERY CONFIRMATION RESPONSE OPTIONS ]════╗ ║ Select Additional ║ ║ Delivery Option -> Signature Required? ║ ║ Request Specific Reply Address? ║ ║ Neither/Exit ║ ╚═══════════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 11 ■ OVERSEAS ZONE CHART At this point (from the QUICK routine option), you are presented with a browse of the overseas zone chart specific to your area, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║ Destination: Hong Kong Area: ║ ║ Express Service Zone: 923 Expedited Service Zone: 623 ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ DEST AREA EXPRESS EXPEDITED ║ ║───────────────────────────────╥─────────────────╥─────────╥────────────────║ ║ Grenada ║ ║ 928 ║ 0 ║ ║ Guadeloupe ║ ║ 928 ║ 0 ║ ║ Guam ║ ║ 929 ║ 0 ║ ║ Guatemala ║ ║ 930 ║ 0 ║ ║ Guinea ║ ║ 932 ║ 0 ║ ║ Guinea-Bissau ║ ║ 932 ║ 0 ║ ║ Guyana ║ ║ 930 ║ 0 ║ ║ Holland ║ Netherlands ║ 921 ║ 621 ║ ║ Honduras ║ ║ 930 ║ 0 ║ ║ Hong Kong ║ ║ 923 ║ 623 ║ ║ Hungary ║ ║ 931 ║ 0 ║ ║ Iceland ║ ║ 929 ║ 0 ║ ║ India ║ Bangalore ║ 930 ║ 0 ║ ║ India ║ Bombay ║ 930 ║ 0 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Select) F3 (Change Weight:5) Find: F5 (Destination) 134/455 Press Enter/Return to display the rate/charges for shipment based on the weight of the package or if it is a letter, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║ The following shipping options exist for you to ship 5 lbs ║ ║ to Cyprus/. ║ ║ ║ ║ Express Service Charge: 97.00 ║ ║ Expedited Service Charge: Not Available ║ ║ ----------------- ║ ║ Other Charges: 6.60 Delivery, C.O.D., Calltag ║ ╚════════════════════════════════════════════════════════════════════════════╝ Press any key to continue... DAYO UPS, TJS LAB, Inc. Page: 12 Press F3 to change the weight you initially inputted, ie: ╔══════════════════════════════════════════════════════════════════════════╗ ║ Enter New Weight: 5 ║ ╚══════════════════════════════════════════════════════════════════════════╝ Press F5 to find a country name. You will be presented with a prompt for the destination (DEST). Note, be sure to use proper case (upper & lower), ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DEST: Korea │ └───────────────────────────────────────────────────TJS LAB───┘ ■ PRINT UPS MANIFEST - ALT M Press Alt M to print the UPS manifest for today. Your options are to set the line spacing per page (defaults to 55), and to direct the output to printer or file. The progress of the printing is printed onto the screen, ie: ╔════════════════════════════════════════════════════════════════════════════ ║ This routine prints the UPS Manifest onto your printer or to a file. ║ ║ Enter Pickup Record Number To Print: 0 ║ ║ Enter the Number of Lines Per Page: 55 ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ Enter File Name: MANIFEST.TXT ║ Invoice Name State Zone Wt Charges COD Amt DV ║ 70 79.70 47.44 37.00 ║ ------ -------------------- ---- ---- ---- --------- --------- --------- ║ 6271 HERSHEY PASTA GROUP PA 12 1 5.25 0.00 0.00 ║ 6270 GATORZ SPORT OPTIKS CA 22 34 13.50 47.44 34.00 ║ 6268 GORILLA SYSTEMS OK 5 1 2.95 0.00 0.00 ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════ Esc (Exit) DAYO UPS, TJS LAB, Inc. Page: 13 ■ MANIFEST FIELDS ON REPORT - PART I Invoice Number Weight Tracking ID Charges Name/Address Amount City Value State Trac Zip Code Size Zone Tag ■ EXAMPLE OF MANIFEST REPORT - PART 2 UPS Shipping Manifest Summary ----------------------------- Your Company Name UPS Shipper Number: 123-456 100 East Mercy Drive Pickup Record Number: 123456789 Building #2001 Anycity, CA 12345-1, FL 32810 (407) 292-4708 Date Shipped: Sunday, 28 June 1992 12:57:54 Page 1 Type Service: Common Carrier Air Zone Pieces Weight Charges Zone Pieces Weight Charges ---- ------- ------ ---------- ---- ------- ------ ---------- 2 - - - - - - - - - - - - 0 14 222 113.75 3 - - - - - - - - - - - - 12 3 25 36.25 4 - - - - - - - - - - - - 22 2 68 71.50 5 1 1 2.95 - - - - - - - - - - - - 6 - - - - - - - - - - - - - - - - - - - - - - - - 7 - - - - - - - - - - - - - - - - - - - - - - - - 8 - - - - - - - - - - - - - - - - - - - - - - - - ------- ------ ---------- ---- ------- ------ ---------- Totals 1 1 2.95 19 315 221.50 |----------------------------------------|-----------------------------------| | Number of GROUNDTRAC packages: 0 | COD Charges: 3,434,456.59 | |----------------------------------------|-----------------------------------| | Number of COD's: 7 | Total UPS Revenue: 230.45 | |----------------------------------------|-----------------------------------| DAYO UPS, TJS LAB, Inc. Page: 13.1 ■ IMPORT INVOICES/RECORDS If you have DAYO POS, Billing & Invoicing or Subscriptions installed and using it to create invoices, you can use this routine to create manifest records for all invoices or subscriptions that are to be shipped via UPS. The invoices or subscriptions must have the term 'UPS' as part of the SHIPPER code on the invoice record, ie: UPS GROUND UPS BLUE UPS RED UPS LETTER Press Alt I to start the import routine. If you have installed DAYO Subscriptions into the DAYO POS (or Billing & Invoicing) directory, you will be given the option to select an import from either the invoice or subscription databases, ie: ╔═════════════════════════════════════════════════════════════════════╗ ║ DAYO Subscriptions were found in the DAYO POS directory. ║ ║ You have the option to import from either. ║ ║ ║ ║ Select Import Option -> From POS (Point of Sale) Invoices ║ ║ From Subscriptions ║ ║ Exit ║ ╚═════════════════════════════════════════════════════════════════════╝ If you haven't installed Subscriptions, a prompt comes up requesting you to select the range of invoices you want to import, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║ This routine will import all invoices from your DAYO POS or Billing & ║ ║ Invoicing databases into today's manifest. ║ ║ Invoices must be printed (PRINTED=.T.) and not deleted! ║ ║ ║ ║ Select Option -> Import Today's Invoices Only ║ ║ Import All Invoices Not Already In UPS Manifest/History ║ ║ Select Date Range ║ ║ Exit ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 13.2 After selecting the range, the progress of the import is displayed onto the screen, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║ This routine will import all invoices from your DAYO POS or Billing & ║ ║ Invoicing databases into today's manifest. ║ ║ Invoices must be printed (PRINTED=.T.) and not deleted! ║ ║ ║ ║ Select Option -> Import All Invoices Not Already In UPS Manifest/History ║ ║ ║ ║┌──────────────────────────────────────────────────────────────────────────┐║ ║│██████████████████████ Invoices Selected For Import ██████████████████████│║ ║│ 58 Liz Watcher UPS GROUND 120.00 07/01/92 │║ ║│ │║ ║├──────────────────────────────────────────────────────────────────────────┤║ ║│███████████████████████████ Invoices Rejected ████████████████████████████│║ ║│ 61 Mary Morgan PICKUP 140.00 07/01/92 │║ ║│ 58 Steve Perkins DELIVERY 10.21 07/01/92 │║ ║│ 56 Andy Altizer FEDERAL EXPRESS 156.00 07/01/92 │║ ║│ 45 Ann LaRossa TRUCK 15.20 07/01/92 │║ ║└──────────────────────────────────────────────────────────────────────────┘║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 14 ■ POST UPS MANIFEST RECORDS When you are finished adding UPS manifest records, AND HAVE PRINTED the manifest, press Alt P to post all records into the UPS history database, UPS.DBF. After adding all records to the UPS history database, they are removed (PACKed) from todays database (UPSTEMP.DBF). ┌────────────────────────────────────────────────────────────────────────────┐ │ │ │ ██▄████ ▄█████▄ ▄█████ ████████ ████ ██ ██ ▄█████ ██ │ │ ██ ██ ██ ██ ██ ██ ██ ███ ██ ██ ██ │ │ ███████ ██ ██ █████▄ ██ ██ ██████ ██ ███ ██ │ │ ██ ██ ██ ██ ██ ██ ██ ███ ██ ██ ██ │ │ ██ ▀█████▀ █████▀ ██ ████ ██ ██ ▀████▀ ▄▄ │ │ │ │ Appending data/records into UPS History database: UPS.DBF │ │ │ └────────────────────────────────────────────────────────────────────────────┘ After todays records are removed, and the database empty, it is reindexed, ie: ┌──────────────────────────────────────────────────────────┐ │ Database Name: UPSTEMP.DBF │ │ Index Name: UPSTRACT.NTX │ │ Index Key: TRACKINGID │ │ Number of Records: 0 │ │ ┌──────────────────────────────────────────────────┐ │ │ │▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓│ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, Inc. Page: 15 ■ BIG LABEL - ALT 1 Press Alt 1 to print a 'big label onto your printer. This label is generally about 3 by 4 inches (18 lines long). You can get these labels preprinted with your company name/logo. Before the label prints, it is displayed onto the screen. Press any key to start the printing after aligning your printer/labels. ╔═ Make Sure Your Label Is Lined Up, Then Press Any Key To Continue... ══╗ ║ Name Jone, Inc. ║ ║ Attention Joe ║ ║ Address 123 East River Road ║ ║ Building 1000 ║ ║ City, State Zip Eigar Pass, CA 98102 ║ ╚════════════════════════════════════════════════════════════════════════╝ ■ STANDARD LABEL - ALT 2 Press Alt 2 to print a standard mailing label onto your printer. Standard labels are 3.5 inches by 15/16 inches and are found in all office supply stores. ■ COD LABEL - ALT 3 Press Alt 3 to print a COD label onto your printer. These labels are currently 'given' to UPS account holders upon request. Before the label prints, the key fields are displayed onto the screen. Press any key to start the printing after aligning your printer/labels. ╔═══════════════ Make Sure Your C.O.D. Label Is Lined Up! ═══════════════╗ ║ Name Jone, Inc. ║ ║ Attention Joe ║ ║ Address 123 East River Road ║ ║ Building 1000 ║ ║ City, State Zip Eigar Pass, CA 98102 ║ ╚════════════════════════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 16 ■ UPS LABEL - ALT 4 Press Alt 4 to print the UPS label onto the printer. This label is the same type used to print standard mailing addresses. Its dimensions are 3.5 by 15/16 inches and are found in all office supply stores. It consists of your STATE abbreviation, your UPS account number, and the invoice number (if not empty), ie: *************************** * UPS Number: FL 123-456 * * Invoice: 10001 * *************************** ■ FIND UPS MANIFEST RECORD - F5/F6/F7/F8/F9/F10 Todays UPS records are generally located by using the arrow keys (up/down), but if you have many records, you can quickly locate a record by selecting/using 1 of 6 index, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter INVOICE: 10001 │ └───────────────────────────────────────────────────TJS LAB───┘ ┌─────────────────────────────────────────────────────────────┐ │ Enter TRACKINGID: 123456789 │ └───────────────────────────────────────────────────TJS LAB───┘ ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: GEORGE MOONILAL │ └───────────────────────────────────────────────────TJS LAB───┘ ┌─────────────────────────────────────────────────────────────┐ │ Enter ZIP: 32810 │ └───────────────────────────────────────────────────TJS LAB───┘ ┌─────────────────────────────────────────────────────────────┐ │ Enter ZONE: 5 │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO UPS, TJS LAB, Inc. Page: 17 ■ BROWSE UPS MANIFEST HISTORY DATABASE Select the 2nd main menu option to browse/edit all manifest records since you started using this program. ╔════════════════════════════════════════════════════════════════════════════╗ ║ Invoice: 20418 Tracking ID: Zone: 2 ███████ Res ║ ║ Name: Brian Larkin Carter Weight: 1 ║ ║ Address: 615 Cole Road Charges: 6.95 ║ ║ COD Amount: 1.00 ║ ║ City: Sanford Declared Value: 0.00 ║ ║ State: MI Zip: 42347 Invoice Amount: 1.00 ║ ║ Ground Trac: N Oversized: Y Call Tag: N Other: 4.00 ║ ║ Insurance: 0.00 Confirm Delivery: N Date: 06/22/92 ║ ╟─────────[ ■ ■ ■ BROWSE THE UPS MANIFEST HISTORY DATABASE ■ ■ ■ ]─────────╢ ║ NUMBER INVOICE TRACKINGID NAME ║ ║─────────────╥────────────╥──────────────╥──────────────────────────────────║ ║ 12001 ║ 20418 ║ ║ Brian Larkin Carter ║ ║ 12002 ║ 20419 ║ ║ Harriet Jones ║ ║ 12003 ║ 20420 ║ ║ Stacy Marting ║ ║ 12004 ║ 20421 ║ 123456789012 ║ George Foster Harrianginton ║ ║ 12005 ║ 20422 ║ ║ Mickel Martin Mueker ║ ║ 12006 ║ 20423 ║ ║ Betty James Junior ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F2 or Alt F2 (Edit) Ctrl N (Add) Ctrl U (Delete) Alt F (Fast) Enter (Compute) F3 (COD) F4 (Quick) Alt R (Reset) Alt M (Print) Alt 1(Big Label) Alt 2(Standard Label) Alt 3(COD Label) Alt 4(UPS Label) Find: F5(Invoice) F6(Tracking ID) F7(Name) F8(Number) F9(Zip) F10(Zone) ■ FAST FIND The only difference in this routine from the browse of todays database is the fast find function (Alt F). When using this option, you need only to input a part or parts of the name, invoice and/or zip code. In the following example, the input of 'carter' locates 2 records, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║ ■ CONSIGNEE (NAME-INVOICE-ZIP) FAST FIND ■ ║ ║ Name Invoice Zip Code Number Date ║ ║ Brian Carter 22304 48657 214 04/23/92 ║ ║ Stacy Carter 33049 35865 334 06/01/92 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Enter String(s): carter ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter (Select) F1 (Help) DAYO UPS, TJS LAB, Inc. Page: 18 ■ QUICK CHECK Select the 3rd option from the main menu to determine the total charges for a shipment to any location in the United States, Canada and many overseas areas. The first prompt is for the major destination: U.S., Canada or all others (overseas), ie: ╔══════════════════════════════[ QUICK CHECK ]═══════════════════════════════╗ ║ This routine will compute the UPS shipping charges for shipments to ║ ║ any location in the continental U.S., Alaska, Hawaii, Puerto Rico, ║ ║ Canada, and many overseas countries... ──────────────────────────── ║ ║ Select Destination -> U.S.A. ║ ║ Canada ║ ║ All Others ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ █████░ █░ █░ ███░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ █░ █░ ║ ║ █░ █░ █░ █░ █░ █░ █░██░ █░ █░ █░ █░ █░ █░██░ ║ ║ █░ █░ █░ █░ █░ █░ ███░ █░ ████░ ██░ █░ ███░ ║ ║ █░ █░ █░ █░ █░ █░ █░██░ █░ █░ █░ █░ █░ █░██░ ║ ║ ▀███▀█░ ████░ ███░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ █░ █░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO UPS, TJS LAB, Inc. Page: 19 Then next prompt is to select which type of shipment you want; standard (regular ground) or ground trac (ground with tracking), ie: ╔══════════════════════════════[ QUICK CHECK ]═══════════════════════════════╗ ║ This routine will compute the UPS shipping charges for shipments to ║ ║ any location in the continental U.S., Alaska, Hawaii, Puerto Rico, ║ ║ Canada, and many overseas countries... ──────────────────────────── ║ ║ Select Option -> Standard 8 June 1992 ║ ║ Ground Trac ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ █████░ █░ █░ ███░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ █░ █░ ║ ║ █░ █░ █░ █░ █░ █░ █░██░ █░ █░ █░ █░ █░ █░██░ ║ ║ █░ █░ █░ █░ █░ █░ ███░ █░ ████░ ██░ █░ ███░ ║ ║ █░ █░ █░ █░ █░ █░ █░██░ █░ █░ █░ █░ █░ █░██░ ║ ║ ▀███▀█░ ████░ ███░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ █░ █░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO UPS, TJS LAB, Inc. Page: 20 The next prompt is to input UPS options like insurance/declared value, COD amount, call tag, delivery confirmation, letter or weight, zip code or postal code, weight and state abbreviation, ie: ╔══════════════════════════════[ QUICK CHECK ]═══════════════════════════════╗ ║ This routine will compute the UPS shipping charges for shipments to ║ ║ any location in the continental U.S., Alaska, Hawaii, Puerto Rico, ║ ║ Canada, and many overseas countries... ──────────────────────────── ║ ║ Select Option ->.Ground Trac Today: Sunday, 28 June 1992 ║ ║ Declared Value: 0.00 Letter?: N ║ ║ C.O.D.?: Y Zip/Postal Code: 740 ║ ║ Call Tag?: Y Weight (in lbs): 5 ║ ║ Delivery Confirmation?: Y State Abbreviation: OK ║ ║ Required For AK, HI & PR ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ █████░ █░ █░ ███░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ █░ █░ ║ ║ █░ █░ █░ █░ █░ █░ █░██░ █░ █░ █░ █░ █░ █░██░ ║ ║ █░ █░ █░ █░ █░ █░ ███░ █░ ████░ ██░ █░ ███░ ║ ║ █░ █░ █░ █░ █░ █░ █░██░ █░ █░ █░ █░ █░ █░██░ ║ ║ ▀███▀█░ ████░ ███░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ █░ █░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) PgDn/PgUp (Save & Continue) If you selected the delivery confirmation option, you will also be prompted with the options for a signature or repy request, ie: ╔══[ ADDITIONAL DELIVERY CONFIRMATION RESPONSE OPTIONS ]════╗ ║ Select Additional ║ ║ Delivery Option -> Signature Required? ║ ║ Request Specific Reply Address? ║ ║ Neither/Exit ║ ╚═══════════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 21 The final screen for U.S. and Canada will contain up to four (4) options as seen in the middle of the following screen/example: ╔══════════════════════════════[ QUICK CHECK ]═══════════════════════════════╗ ║ This routine will compute the UPS shipping charges for shipments to ║ ║ any location in the continental U.S., Alaska, Hawaii, Puerto Rico, ║ ║ Canada, and many overseas countries... ──────────────────────────── ║ ║ Select Option ->.Ground Trac Today: Sunday, 28 June 1992 ║ ║ Declared Value: 0.00 Letter?: N ║ ║ C.O.D.?: Y Zip/Postal Code: 740 ║ ║ Call Tag?: Y Weight (in lbs): 5 ║ ║ Delivery Confirmation?: Y State Abbreviation: OK ║ ║ Required For AK, HI & PR ║ ║ ┌─ Zone 5, Ground: 3.21 + Charges: 9.56 ║ ║ │ Zone 5, Residential: 3.66 + Charges: 10.01 ║ ║ │ Zone 12, 2nd Day: 8.00 + Charges: 14.35 ║ ║ └─ Zone 22, Next Day Air: 19.25 + Charges: 25.60 ║ ║ ║ ║ Charges: 6.35 Delivery, C.O.D., Calltag ║ ╟──────────────────────[ Estimated Delivery Schedule ]───────────────────────╢ ║ * Next Day, 2 days ** 2nd Day, 5 days *** Ground, 9.0 days ║ ║ * ** *** ║ ║06/28 06/29 06/30 07/01 07/02 07/03 07/04 07/05 07/06 07/07 07/08 07/09 07/1║ ║ └─────┴─────┴─────┴─────┴─────┴─────┴─────┴─────┴─────┴─────┴─────┴─────┘ ║ ║Today Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri║ ╚════════════════════════════════════════════════════════════════════════════╝ Press any key to continue... DAYO UPS, TJS LAB, Inc. Page: 22 If you selected the 'All Others' option, a browse of all countries and territories that UPS ships to will be displayed. Just press enter/return on the desired destination to get the rate/charge, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║ Destination: Hong Kong Area: ║ ║ Express Service Zone: 923 Expedited Service Zone: 623 ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ DEST AREA EXPRESS EXPEDITED ║ ║───────────────────────────────╥─────────────────╥─────────╥────────────────║ ║ Grenada ║ ║ 928 ║ 0 ║ ║ Guadeloupe ║ ║ 928 ║ 0 ║ ║ Guam ║ ║ 929 ║ 0 ║ ║ Guatemala ║ ║ 930 ║ 0 ║ ║ Guinea ║ ║ 932 ║ 0 ║ ║ Guinea-Bissau ║ ║ 932 ║ 0 ║ ║ Guyana ║ ║ 930 ║ 0 ║ ║ Holland ║ Netherlands ║ 921 ║ 621 ║ ║ Honduras ║ ║ 930 ║ 0 ║ ║ Hong Kong ║ ║ 923 ║ 623 ║ ║ Hungary ║ ║ 931 ║ 0 ║ ║ Iceland ║ ║ 929 ║ 0 ║ ║ India ║ Bangalore ║ 930 ║ 0 ║ ║ India ║ Bombay ║ 930 ║ 0 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Select) F3 (Change Weight:5) Find: F5 (Destination) 134/455 DAYO UPS, TJS LAB, Inc. Page: 23 ■ REPORTS This section provides you reports for all data in this module. Also as part of this section, is a routine to set up your printer and to view reports written to disk or file. DAYOUPS Version 1.0, Copyright(c) 1992 TJS LAB, Inc, Orlando, Florida ╔═════════════════════════════╗══╗ ┌─────[June 1992]────┐ ║ DAYO POINT OF SALE REPORTS ║t ║ │S M T W T F S │ ║ Printer Setup ║──╢ ├────────────────────┤ ║ USA Zone Chart ║ ║ │ 1 2 3 4 5 6│ ║ USA Rates ║ ║ │ 7 8 9 10 11 12 13│ ║ USA Ground Trac Rates ║ ║ │14 15 16 17 18 19 20│ ║ Canada Ground Zones ║ ║ │21 22 23 24 25 26 27│ ║ Canada Air Zones ║ ║ │28 29 30 │ ║ Canada Ground & Air Rates ║ ║ │ │ ║ Overseas Zones ║──╢ └────────────────────┘ ║ Overseas Express Rates ║ ║ ║ Overseas Expedite Rates ║══╝ ║ Manifest Reprint ║══════════════════════════════════════════════╗ ║ UPS Expanded ║ █░ ██░ █░ █░ ███░ ████░ ████░ ████░ █████░║ ║ UPS Summary ║░██░ █▀▀█░ ██░█░ █░ █░ █░ █░ █░ ║ ║ Config Status ║███░ ████░ ████░ █░ ███░ ███░ ████░ █░ ║ ║ View Reports On Screen ║█░█░ █░ █░ █░██░ █░ █░ █░ █░ █░ ║ ║ ║ █░ █░ █░ █░ █░ ███░ █░ ████░ ████░ █░ ║ ║ ║══════════════════════════════════════════════╝ ║ ║ ║ ║ ║ SELECT REPORT ║ ╚═════════════════════════════╝ Esc (Exit) Enter/Return (Select Report Option) DAYO UPS, TJS LAB, Inc. Page: 24 ■ PRINTER SETUP (DRIVER) This routine was added to prevent you from having to get out of your seat to change the current printer settings. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer DAYO UPS, TJS LAB, Inc. Page: 25 ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) 1/4 DAYO UPS, TJS LAB, Inc. Page: 26 ■ FULL SCREEN EDIT - F2 When entering the printer codes, the string must be in the valid format or it will not be printed later when requested... ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐ │ NAME: Epson & Compatibles │ │ LINEFEED: CHR(10) │ │ NORMAL: CHR(27)+CHR(18) │ │ SMALL: CHR(27)+CHR(15) │ │ BOLDON: CHR(27)+CHR(69) │ │ BOLDOFF: CHR(27)+CHR(70) │ │ _6LPI: CHR(27)+CHR(50) │ │ _8LPI: CHR(27)+CHR(48) │ │ PORTRAIT: │ │ LANDSCAPE: │ │ RESET: CHR(27)+CHR(64) │ │ SPEC_STR1: │ │ SPEC_STR2: │ │ SPEC_STR3: │ │ SPEC_STR4: │ │ SPEC_STR5: │ │ RUN_CMD: │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS NAME - Name of printer. Type in anything you wish here LINEFEED - Code to advance printer one line NORMAL - Normal font/character size SMALL - Small font/character size BOLDON - Bold/Emphasized BOLDOFF - Bold/Emphasized off _6LPI - Code to set printer to print 6 lines per inch _8LPI - Code to set printer to print 8 lines per inch PORTRAIT - Code to set laser printer to print upright (normal) LANDSCAPE - Code to set laser printer to print sideways RESET - Reset printer code SPEC_STR1 - Any special printer string, ie: print double, skip perforation, SPEC_STR2 - print very tiny, etc SPEC_STR3 - " SPEC_STR4 - " SPEC_STR5 - " RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, etc DAYO UPS, TJS LAB, Inc. Page: 27 ■ UPS LOCAL ZONE CHART This reports a list of your local UPS Zones. This chart is inputted by you at time of installation. Check your UPS Zone Chart supplied to you by UPS for accuracy. Note, you can print this report to printer or file. If you print to a file, you can use the 'View Reports' option to view the report onscreen (saves paper)... ╔══════════════════════════[ UPS LOCAL ZONE CHART ]═════╗ ║This report prints out to printer or file the local ║ ║UPS Zone Chart. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ ║ ║Enter File Name: UPSZONE.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ UPS RATE TABLE This reports the local UPS Ground and Air Rate Table/Chart supplied to you by TJS LAB, Inc. You can direct the output of this report to a printer or to a disk file. ╔═════════════════════════════[ UPS RATE TABLE ]════════╗ ║This report prints out to printer or file the local ║ ║UPS Ground & Air Rate Table/Chart. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ ║ ║Enter File Name: UPSTABLE.TXT ║ ╚═══════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 28 ■ UPS GROUND TRAC RATE TABLE This reports the local UPS 'Ground Trac' Ground and Air Rate Table/Chart supplied to you by TJS LAB, Inc. You can direct the output of this report to printer or to a disk file. ╔═══════════════════════[ UPS GROUND TRAC RATE TABLE ]══╗ ║This report prints out to printer or file the local ║ ║UPS Ground Trac (and Air) Rate Table/Chart. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ ║ ║Enter File Name: UPSTRAC.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ CANADA GROUND ZONE CHART This reports the local UPS Ground Zones for shipments to Canada. This file is different for areas around the country. Be sure you have the right database entered into the Configuration Settings. You can direct the output of this report to printer or to a disk file. ╔════════════════════════[ CANADA GROUND ZONE CHART ]═══╗ ║This report prints out to printer or file the local ║ ║UPS Ground Zones to Canada. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ ║ ║Enter File Name: CANADAG.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ CANADA AIR ZONE CHART This reports the local UPS Air Zones for shipments to Canada. Note, this file is different for areas around the country. Be sure you have the right database entered into the Configuration Settings. DAYO UPS, TJS LAB, Inc. Page: 29 You can direct the output of this report to printer or to a disk file. ╔═════════════════════════[ CANADA AIR ZONE CHART ]═════╗ ║This report prints out to printer or file the Air ║ ║Zone Chart for shipments to Canada. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: ZONEAIR.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ CANADA GROUND RATE TABLE This reports the UPS Ground Rate Table/Chart. Note, this file is different for areas around the country. Be sure you have the right database entered into the Configuration Settings. You can direct the output of this report to printer or to a disk file. ╔════════════════════════[ CANADA GROUND RATE TABLE ]═══╗ ║This report prints out to printer or file the local ║ ║UPS Ground and Air Rates to Canada. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CANADAZ.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ OVERSEAS ZONE CHART This reports the local UPS Zones for Overseas shipments. Note, this file is different for areas around the country. Be sure you have the right database entered into the Configuration Settings. You can direct the output of this report to printer or to a disk file. ╔══════════════════════════[ OVERSEAS ZONE CHART ]══════╗ ║This report prints out to printer or file the local ║ ║UPS Zone Chart for Overseas areas. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: OZONES.TXT ║ ╚═══════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 30 ■ OVERSEAS AIR EXPRESS RATE CHART This reports the local UPS Express Rates for Overseas shipments. This file is different for areas around the country. Be sure you have the right database entered into the Configuration Settings. You can direct the output of this report to printer or to a disk file. ╔════════════════════[ OVERSEAS AIR EXPRESS RATE CHART ]╗ ║This report prints out to printer or file the local ║ ║UPS Overseas Air EXPRESS Rate Chart. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ ║ ║Enter File Name: EXPRESS.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ OVERSEAS AIR EXPEDITE RATE CHART This reports the local UPS Expedite Rates for Overseas shipments. This file is different for areas around the country. Be sure you have the right database entered into the Configuration Settings. You can direct the output of this report to printer or to a disk file. ╔════════════════════[ OVERSEAS AIR EXPEDITE RATE CHART ] ║This report prints out to printer or file the local ║ ║UPS Overseas Air EXPEDITE Rate Chart. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ ║ ║Enter File Name: EXPEDITE.TXT ║ ╚═══════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 31 ■ REPRINT MANIFEST This report is usually printed at the end of each day, but is provided here for reprint/review. The first prompt is for the Pickup Number (usually nine (9) digits). Other options include the number of lines per page, and output to printer or file. The progress of the report is displayed onto the screen, ie: ╔════════════════════════════════════════════════════════════════════════════╗ ║ This routine prints the UPS Manifest onto your printer or to a file. ║ ║ ║ ║ Enter Pickup Record Number To Print: 123456789 ║ ║ ║ ║ Enter the Number of Lines Per Page: 55 ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ Enter File Name: MANIFEST.TXT ║ ║ Invoice Name State Zone Wt Charges COD Amt DV ║ ║ ║ ║ 26675 HERSHEY PASTA GROUP PA 12 1 5.25 0.00 0.00 ║ ║ 26674 GATORZ SPORT OPTIKS CA 22 34 13.50 200.00 0.00 ║ ║ 26672 GORILLA SYSTEMS OK 5 1 2.95 0.00 0.00 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO UPS, TJS LAB, Inc. Page: 32 ■ UPS EXPANDED REPORT This report prints out an expanded list of manifest records found in the history database (UPS.DBF). Fields include: Tracking ID, Name & Address, Date, Trac?, Letter?, Residential?, Call Tag?, Delivery Confirmation?, Signature?, Weight, Shipping Charges, Invoice Amount, Insurance/Value and Zone. Options include date range, multiple indexes, heading/title, and output to printer or file. The report is 80 characters wide and uses form: UPS.FRM. ╔══════════════════════════[ UPS EXPANDED REPORT ]══════╗ ║This report prints out an expanded list of manifest ║ ║records. Options include date range, index, ║ ║heading/title, and output (to printer or file). ║ ║Report is 80 characters wide and named: UPS.FRM ║ ║ ║ ║Enter Start Date: 05/30/92 Ending Date: 06/29/92 ║ ║ ║ ║Select Index -> Invoice Number ║ ║ ║ ║Enter Heading: Your Company Name ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: UPS.TXT ║ ║ ████ █ █ █▄██ ▄██▄ █ █ █▄██ ████ █▄██ ║ ║ █ █ █ █ █ █ █ ██ █ █ █ █ █ █ ║ ║ ███ █ ████ ████ ████ █ █ ███ █ █ ║ ║ █ █ █ █ █ █ █ ██ █ █ █ █ █ ║ ║ ████ █ █ █ █ █ █ █ █▀██ ████ █▀██ ║ ╚═══════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 33 ■ UPS SUMMARY REPORT This report prints out a summary of all numeric fields in the UPS history database (UPS.DBF). Fields inlcude: weight, rate charges, other charges (ie: call tag), COD amount, declared value and invoice amount. Options include date range, multiple indexes, heading/title, and output to printer or file. The report is 80 characters wide and uses form: UPS.FRM. ╔═══════════════════════════[ UPS SUMMARY REPORT ]══════╗ ║This report prints out a summary of manifest records. ║ ║Options include date range, index, heading/title, and ║ ║output (to printer or file). ║ ║Report is 80 characters wide and named: UPSSUM.FRM ║ ║ ║ ║Enter Start Date: 05/30/92 Ending Date: 06/29/92 ║ ║ ║ ║Select Index -> Invoice Number ║ ║ ║ ║Enter Heading: Your Company Name ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: UPSSUM.TXT ║ ║ ████ █ █ █ █ █ █ ▄██▄ █▄██ █ █ ║ ║ █ █ █ ██ ██ ██ ██ █ █ █ █ █▄ ▄█ ║ ║ ████ █ █ ███ ███ ███ ███ ████ ████ █▄█ ║ ║ █ █ █ █ ███ █ █ ███ █ █ █ █ █ █ ║ ║ ████ ████ █ █ █ █ █ █ █ █ █ ██ █ ║ ╚═══════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 34 ■ EXAMPLE OF UPS SUMMARY REPORT Page No. 1 Your Company Name Date Range From: 05/30/44 to 06/29/92 06/29/92 UPS MANIFEST RECORD SUMMARY REPORT ---------------------------------- OTHER COD DECLARED INVOICE WEIGHT CHARGES CHARGES AMOUNT VALUE AMOUNT ---------- ----------- ----------- ----------- ----------- ----------- 1 2.30 0.00 1000.00 2000.00 1000.00 10 5.30 4.00 0.00 0.00 10.00 *** Total *** 11 7.60 4.00 1000.00 2000.00 1010.00 ■ CONFIGURATION REPORT This report lists all your configuration options. You can direct the output of this report to a printer or to a disk file. ╔═══════════════════════════════════════════════════════╗ ║The Configuration Status Settings Report lists all of ║ ║configuration settings (found in file DAYOUPS.CFG). ║ ║This is Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CONFIG.TXT ║ ╚═══════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB, Inc. Page: 35 ■ EXAMPLE OF CONFIGURATION REPORT +++++++++++++++++++++++++++++++++++++++++++++++ + DAYO UPS CONFIGURATION REPORT + +++++++++++++++++++++++++++++++++++++++++++++++ 06/29/92 03:18:57 Company Name: Your Company Name Address Line 1: 100 East Mercy Drive Address Line 2: Building #2001 City: Anycity, CA 12345-1 State: FL Zip: 32810 Telephone: (407) 292-4708 UPS Shipper Number: 123-456 Inventory Database Location: \DAYOINV\ POS/Invoice Database Location: \DAYOPOS\ Current Database Location: Report Printer Type: LASER PRINTER Report Printer Port: LPT1 Automatically Reindex Daily: Yes Color: Yes High Intensity: Yes UPS Default Settings Mainly ships C.O.D.: Yes Usually use Call Tags: Yes Delivery Confirm. Response: Yes Overseas Zones: ZONEIAZ.DBF Canada Ground Zones: ZONECGAR.DBF Overseas Express Rates: EXPRSAK.DBF Overseas Expedite Rates: EXPRSAK.DBF Big Label Printer Port LPT: 1 Std Label Printer Port LPT: 1 COD Label Printer Port LPT: 1 UPS Number Label Port LPT: 1 Manifest Printer Port LPT: 1 Manifest Printer Type: STANDARD UPS Default Rates/Charges C.O.D.: 4.00 Call Tag: 1.60 Address Correction: 3.50 Hazardous Materials: 5.00 Delivery Confirm: 0.75 Signature Required: 0.25 Specific Address Reply: 0.25 Saturday Delivery: 10.00 Insurance: 0.30000 Insurance Limit: 25,000.00 Last Pickup Record Number: 123456789 Last Pickup Record Date: 06/28/92 DAYO UPS, TJS LAB, Inc. Page: 36 ■ VIEW REPORTS ON SCREEN This routine was provided to aid the 'fight to stop the cutting down of trees in the world' by offering you the option to view your reports on your screen. The only limitation is on the size of the report. No reports can be viewed if they are over 32,000 bytes. (Just kidding about those trees...) Due to compiler problems (handling of memory), this routine tends to 'hang' your computer. It is not recommended you use this option if your machine is performing multitasking programs. At the first prompt, type and enter the name of the report you wish to view. ╔═════════════════════════▌ View Reports Onscreen ▐══════════════════════════╗ ║██ ██░ ████░ ████░ ██░ ██░ ██▄██░ █████░ ██▄██░ ▄███▄ ██▄██░ ██████║ ║ ██ ██░ ██░ ██░ ██░ █░ ██░ ██░██░ ██░ ██░██░ ██░██░ ██░██░ ██░ ║ ║ ██ ██░ ██░ ███░ ██░███░██░ █████░ ████░ █████░ ██░██░ █████░ ██░ ║ ║ ████░ ██░ ██░ ███░███░ ██▀█░ ██░ ██░ ██░██░ ██▀█░ ██░ ║ ║ ██░ ████░ ████░ ██░██░ ██░██░ █████░ ██░ ▀███▀ ██░██░ ██░ ║ ║ ║ ║ Use this option to view (and optionally print) any report written to disk. ║ ║ Press Enter/Return on an empty prompt to display all files with the ║ ║ extension of '.TXT'. ║ ║ No limit on file size, but a large file/report takes longer to 'load'... ║ ║ ║ ║ Enter Report File Name to View On Screen: ║ ╚════════════════════════════════════════════════════════════════════════════╝ If the file does not exist, or you press enter on an empty prompt, a window will appear showing all reports in the current directory. It is assumed that all reports will have the extension of '.TXT', which is the DAYO standard. All reports are displayed in the window, even if they are too large... ╔═══════════════════════════════════════╗ ║ File Name Size Date Used ║ ╟──────────────┬────────────┬───────────╢ ║DAYOERR.TXT │ 1090 │ 06/15/90 ║ ║BALANCE.TXT │ 3555 │ 06/15/90 ║ ║GL900615.TXT │ 79 │ 06/15/90 ║ ║CONFIG.TXT │ 1209 │ 06/15/90 ║ ║BUDGETSC.TXT │ 4129 │ 06/15/90 ║ ║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐ ║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │ ║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │ ║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │ ║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │ ║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘ ║TRANS1.TXT │ 659 │ 06/15/90 ║ ╚══════════════╧════════════╧═══════════╝ DAYO UPS, TJS LAB, INC. Page: 37 ■ REPORT VIEWING SCREEN The report viewing screen uses the complete screen. The top line displays the report name. The bottom lines show you the function keys. Also displayed at the bottom of the screen is the current row/column of the cursor position. DAYORPT View Reports │ File Name: COA.TXT Page No. 1 07/27/90 INVENTORY ITEM LISTING Vendor or Item Mfg Item Description ------------ ------------ ------------------------------ 2" GUTTER 2" GUTTER SYSTEM _____________ 2ALM518 2" ALMOND COIL _____________ 2ALM519 2" ALMOND COIL _____________ 2ALM527 2" ALMOND COIL _____________ 2ALM533 2" ALMOND COIL _____________ 2ANT123 2" ANT IVORY COIL _____________ Esc (Exit) F1 (Help) DAYO UPS, TJS LAB, Inc. Page: 38 ■ CONFIGURATION DAYOUPS Version 1.0, Copyright(c) 1992 TJS LAB, Inc, Orlando, Florida ╔═══════════════════╔══════════════════════════════════╗┌─────[June 1992]────┐ ║ 1 Browse Today's ║ CONFIGURATION ║│S M T W T F S │ ╟───────────────────╟──────────────────────────────────╢├────────────────────┤ ║ 2 Browse Manifest║ Company Name ║│ 1 2 3 4 5 6│ ║ 3 Quick Rate Chec║ Address ║│ 7 8 9 10 11 12 13│ ║ 4 Reports ║ City ║│14 15 16 17 18 19 20│ ║ 5 Configuration ║ State ║│21 22 23 24 25 26 27│ ║ 6 Information ║ Zip ║│28 29 30 │ ║ 7 Misc Routines ║ Telephone ║│ │ ╟───────────────────║ UPS Shipper Number ║└────────────────────┘ ║ Exit to Dos ║ Inventory Location ║ ╚═══════════════════║ POS Location ║ ╔═══════════════════║ Current Database Location ║═════════════════════╗ ║ ██░ ██░ ██▄███░ █║ UPS Default Rates/Options ║█░ ████░ ████░ █████░║ ║ ██░ ██░ ██░ ██░ █║ Report Printer Type ║ █░ █░ █░ ║ ║ ██░ ██░ ██████░ █║ Report Printer Port ║░ ███░ ████░ █░ ║ ║ ██░ ██░ ██░ ║ Auto Daily Index ║ █░ █░ █░ ║ ║ ██████░ ██░ █║ Color ║ ████░ ████░ █░ ║ ╚═══════════════════║ Intensity ║═════════════════════╝ ║ Canada Ground Zones ║ ╟──────────────────────────────────╢ ║ Select Option ║ Esc (Exit) ╚══════════════════════════════════╝ ■ LIST OF CONFIGURATION OPTIONS/SETTINGS Company Name Color Address Intensity City Canada Ground Zones State Overseas Zones Zip Overseas Express Rates Telephone Overseas Expedite Rates UPS Shipper Number Edit Your Local Zone Chart Inventory Location Last Pickup Record Number POS Location Big Label Printer Port Customer Location Standard Label Printer Port Current Database Location COD Label Printer Port UPS Default Rates/Options UPS Number Label Port Report Printer Type Manifest Printer Port Report Printer Port Manifest Printer Type Auto Daily Index DAYO UPS, TJS LAB, Inc. Page: 39 ■ COMPANY NAME ┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐ │ Enter Your Company Name: Your Company Name │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY ADDRESS ┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐ │ Address Line 1: 100 East Mercy Drive │ │ Address Line 2: Building #2001 │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY STATE Select a valid 2 digit state code, ie: GA, FL, CA, MI... ┌─────────────────────────────[ COMPANY STATE ]──────────────────────────────┐ │ State: FL │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY ZIP Enter a valid 5 or 10 digit zip code... ┌──────────────────────────────[ COMPANY ZIP ]───────────────────────────────┐ │ Zip Code: 32810 │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY TELEPHONE ┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐ │ Enter Your Company Telephone: (407) 292-4708 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, Inc. Page: 40 ■ UPS SHIPPER NUMBER This is your account number assigned to you by UPS. ┌───────────────────────────[ UPS SHIPPER NUMBER ]───────────────────────────┐ │ Enter UPS Shipper Number: 123-456 │ │ ie: 123-456 │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVENTORY LOCATION/DIRECTORY ┌──────────────────────[ INVENTORY LOCATION/DIRECTORY ]──────────────────────┐ │ The location of the DAYO Inventory (INV.DBF) does not have to be in │ │ the same drive/directory as DAYO UPS. If you have installed DAYO Inventory │ │ into a different directory, you need to tell DAYO UPS where to find the │ │ inventory database (INV.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOINV\ │ │ The drive designation is optional (if same as DAYO UPS). │ │ │ │ Enter Location: D:\DAYOINV\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ POS (INVOICING) DATABASE LOCATION/DIRECTORY ┌──────────────[ POS (INVOICING) DATABASE LOCATION/DIRECTORY ]───────────────┐ │ The location of the DAYO POS/Invoice Database (INVOICE.DBF) does not have │ │ to be in the same drive/directory as DAYO UPS. If you have installed DAYO │ │ POS into a different directory, you need to tell DAYO UPS where to find the│ │ invoice database (INVOICE.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOQUO\ │ │ The drive designation is optional (if same as DAYO UPS). │ │ │ │ Enter Location: \dayopos\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, Inc. Page: 40.1 ■ CUSTOMER (AR) DATABASE LOCATION/DIRECTORY ┌───────────────[ CUSTOMER (AR) DATABASE LOCATION/DIRECTORY ]────────────────┐ │The location of the DAYO Customer (AR) Database (CUSTOMER.DBF) does not have│ │to be in the same drive/directory as DAYO UPS. If you have installed DAYO │ │AR into a different directory, you need to tell DAYO UPS where to find the │ │customer database (CUSTOMER.DBF). Default is nil (current directory). │ │Be sure to include the rightmost slash, ie: \DAYOAR\ │ │The drive designation is optional (if same as DAYO UPS). │ │ │ │ Enter Location: \DAYOAR\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ CURRENT DIRECTORY DATABASE LOCATION ┌──────────────────[ CURRENT DIRECTORY DATABASE LOCATION ]───────────────────┐ │ This module's databases can be located in a different location other │ │ than the current directory. If you have and wish to use ALL the │ │ databases currently found in this directory from a different drive and │ │ directory, then you need to tell this module where to find them. │ │ Be sure to include the rightmost slash, ie: L:\DAYOUPS\ │ │ The drive designation is optional if same as this module. │ │ │ │ Enter Location: │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, Inc. Page: 41 ■ UPS DEFAULT RATES/OPTIONS These settings will become the defaults when adding/creating new manifest records. Other settings here are for the rates for UPS options like call tags and delivery confirmation. ┌───────────────────────[ UPS DEFAULT RATES/OPTIONS ]────────────────────────┐ │ These rates and settings are used as the defaults for computing │ │ your shipping charges. │ │ │ │ Default Settings │ │ Do you mainly ship C.O.D.? Y │ │ Do you usually use Call Tags? Y │ │ Do you usually require a Delivery Confirmation Response? Y │ │ │ │ Rates/Charges │ │ C.O.D.: 4.00 Signature Required: 0.25 │ │ Call Tag: 1.60 Specific Address Reply: 0.25 │ │ Address Correction: 3.50 Saturday Delivery: 10.00 │ │ Hazardous Materials: 5.00 Insurance: 0.30000 │ │ Delivery Confirm: 0.75 Insurance Limit: 25000.00 │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER TYPE ┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐ │ Routine reports are printed according to this selection. │ │ The STANDARD printer type is an Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER PORT ┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, Inc. Page: 42 ■ AUTOMATIC DAILY INDEXING Though not required, it is highly recommended that all databases get reindexed each day. Therefore it is recommended that you leave this option set to Yes (on). ┌────────────────────────[ AUTOMATIC DAILY INDEXING ]────────────────────────┐ │ If this option is set to Y (YES), then all DAYO Indexes accessed by │ │ DAYO Inventory will be recreated once daily. This will occur when the │ │ first DAYO Inventory program is run. The default is to recreate all │ │ all the indexes daily... │ │ │ │ Recreate all DAYO Inventory Indexes? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR MONITOR ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐ │ If you have a color monitor and wish to display colors, then select Y, │ │ (YES), else select N (NO) for monochrome and others. │ │ The default is color, low intensity │ │ │ │ Do you have a color monitor? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR INTENSITY ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐ │ Intensity is only applicable with color set to Y. │ │ It will make your colors brighter... │ │ │ │ Set Color Intensity On? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, Inc. Page: 43 ■ CANADA GROUND ZONES This database is unique to specific areas of the U.S. Be sure to select the right one for your local area. ┌──────────────────────────[ CANADA GROUND ZONES ]───────────────────────────┐ │ This is the name of the database that contains the Ground Zones for │ │ Canada. Check the documentation for the name of the database for your │ │ region. │ │ │ │ Enter Name of the Canada Ground Zones Database: │ │ ZONECGAR.DBF │ └────────────────────────────────────────────────────────────────────────────┘ ■ OVERSEAS ZONES This database is unique to specific areas of the U.S. Be sure to select the right one for your local area. ┌─────────────────────────────[ OVERSEAS ZONES ]─────────────────────────────┐ │ This is the name of the database that contains the Overseas Zone Chart. │ │ Check the documentation for the name of the database for your region. │ │ │ │ │ │ Enter Name of the Overseas Zones Database: │ │ ZONEIAZ.DBF │ └────────────────────────────────────────────────────────────────────────────┘ ■ OVERSEAS AIR EXPRESS RATES This database is unique to specific areas of the U.S. Be sure to select the right one for your local area. ┌───────────────────────[ OVERSEAS AIR EXPRESS RATES ]───────────────────────┐ │ This is the name of the database that contains the Overseas Air Express │ │ rates. Check the documentation for the name of the database for your │ │ region. │ │ │ │ Enter Name of the Overseas Air Express Rates Database: │ │ EXPRSAK.DBF │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, Inc. Page: 44 ■ OVERSEAS AIR EXPEDITE RATES This database is unique to specific areas of the U.S. Be sure to select the right one for your local area. ┌──────────────────────[ OVERSEAS AIR EXPEDITE RATES ]───────────────────────┐ │ This is the name of the database that contains the Overseas Air Expedite │ │ rates. Check the documentation for the name of the database for your │ │ region. │ │ │ │ Enter Name of the Overseas Air Express Rates Database: │ │ EXPEDAZ.DBF │ └────────────────────────────────────────────────────────────────────────────┘ ■ EDIT YOUR LOCAL ZONE CHART This database is unique to your location. UPS will give this chart to you, but you will have to input/enter it into this database/table. Be sure to insure accuracy! ┌───────────────────────[ EDIT YOUR LOCAL ZONE CHART ]───────────────────────┐ │ This is database contains the zones specific to your area. Copy this │ │ data from the chart that UPS gave you! │ │ │ │ FROM TO ZONE │ │ ──────────╥─────╥────────── │ │ 4 ║ 5 ║ 5 │ │ 10 ║ 59 ║ 6 │ │ 60 ║ 61 ║ 5 │ │ █ ████ ████ ▄██▄ █ 62 ║ 62 ║ 6 █████ ████ █ █ ███ ███ │ │ █ █ █ █ █ █ █ 63 ║ 89 ║ 5 ██ █ █ ██ █ █ █ │ │ █ █ █ █ ████ █ 100 ║ 119 ║ 5 ██ █ █ ████ ██ ███ │ │ █ █ █ █ █ █ █ 120 ║ 123 ║ 6 ██ █ █ █ ██ █ █ │ │ ███ ████ ████ █ █ ███ 124 ║ 127 ║ 5 █████ ████ █ █ ███ ███ │ │ 128 ║ 136 ║ 6 │ └────────────────────────────────────────────────────────────────────────────┘ Esc (Exit) Enter (Edit) To make a change, highlight a record, then press enter/return. Type in a valid beginning and ending zip code (1st 3 digits), and its corresponding zone (2-8). ┌────────────────────────────────────────────────────────────────────────────┐ │ Zip Code From: 4 To: 5 Zone: 5 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, Inc. Page: 45 ■ LAST PICKUP NUMBER This number is computer generated, but must match your manifest voucher supplied by UPS. ┌───────────────────────────[ LAST PICKUP NUMBER ]───────────────────────────┐ │ This is the last 'Pickup Record Number' used to consecutively │ │ number your daily manifest printouts. Note, this number will not │ │ change on any reprints the same day... │ │ │ │ Enter the Last Pickup Record Number: 123456789 │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ BIG LABEL PRINTER PORT ┌─────────────────────────[ BIG LABEL PRINTER PORT ]─────────────────────────┐ │ Enter the Printer Port (LPT1...LPT3) for Big Mailing Labels LPT:1 <─── │ └────────────────────────────────────────────────────────────────────────────┘ ■ STANDARD LABEL PRINTER PORT ┌──────────────────────[ STANDARD LABEL PRINTER PORT ]───────────────────────┐ │ Enter the Printer Port (LPT1...LPT3) for Standard Mailing Labels LPT:1 <─│ └────────────────────────────────────────────────────────────────────────────┘ ■ COD LABEL PRINTER PORT ┌─────────────────────────[ COD LABEL PRINTER PORT ]─────────────────────────┐ │ Enter the Printer Port (LPT1...LPT3) for COD Mailing Labels LPT:1 <─── │ └────────────────────────────────────────────────────────────────────────────┘ ■ UPS PRINTER PORT ┌────────────────────────────[ UPS PRINTER PORT ]────────────────────────────┐ │ Enter the Printer Port (LPT1...LPT3) for your UPS Labels, LPT:1 <─── │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, Inc. Page: 46 ■ MANIFEST PRINTER PORT ┌─────────────────────────[ MANIFEST PRINTER PORT ]──────────────────────────┐ │ Enter the Printer Port (LPT1...LPT3) for your Manifests LPT:1 <─── │ └────────────────────────────────────────────────────────────────────────────┘ ■ MANIFEST PRINTER TYPE The laser option only works on an HP compatible laser printer. ┌─────────────────────────[ MANIFEST PRINTER TYPE ]──────────────────────────┐ │ │ │ The STANDARD Manifest type is an Epson/IBM Proprinter compatible printer.│ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Select Your Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, Inc. Page: 47 ■ MISCELLANEOUS ROUTINES The MISC routines is a collection of 17 very useful Database Management Routines. These routines provide you with the 'ability to do whatever was left out of the rest of the program...'. These routines were modeled after dBase (tm) III+/IV functions. Familiarity with dBase will help with the understanding and execution of these routines. USE WITH CAUTION! YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES YOU CAN ALSO MESS THINGS UP PERMANENTLY! ■ MISC Routines Menu: DAYOUPS Version 1.0, Copyright(c) 1992 TJS LAB, Inc, Orlando, Florida ╔════════════════════╗═══════════╗ ┌─────[June 1992]────┐ ║ MISC ROUTINES ║S Manifest ║ │S M T W T F S │ ╟────────────────────╢╔═════════════════════════════════════════════════════╗┤ ║ APPEND FROM ║║ This menu option provides you with a multitude of ║│ ║ BROWSE DATABASES ║║ database management tools and functions, but also ║│ ║ COPY (.DBF) TO ║║ can be a source of significant problems! ║│ ║ CREATE DATABASE ║║ ║│ ║ DELETE RECORDS ║║ Miscellaneous Routines was provided to give you a ║│ ║ ERASE FILE ║║ 'back door' to DAYO, but if used incorrectly, it ║│ ║ EXIT TO DOS ║║ can damage or destroy your data! ║┘ ║ INDEX A DATABASE ║║ ║ ║ LIST FIELDS ║║ Adding records to databases, packing, appending, ║ ║ PACK DATABASE ║║ editing records and modify databases can ║╗ ║ MODIFY DATABASE ║║ corrupt the indexes related to the database(s)! ║║ ║ RECALL RECORDS ║║ You must know to reindex (Alt F9) if you do any ║║ ║ RETURN TO MENU ║║ of these operations... ║║ ║ RUN (DOS COMMAND) ║║ ║║ ║ SIMPLE EDITOR ║║ When modifying a database, the rule is to NEVER ║║ ║ SORT DATABASE ║║ change an existing field; only to add new fields.. ║╝ ║ TYPE (PRINT) FILE ║║ ║ ║ ZAP DATABASE ║║ Remember that 'ZAP' means to remove (permanently) ║ ╟────────────────────╢║ all records in the selected database! ║ ║ Select Option ║╚═════════════════════════════════════════════════════╝ ╚════════════════════╝ DAYO UPS, TJS LAB Page: 48 ■ APPEND FROM Used to copy records from one database into another database, or to create records from ASCII files (SDF or DELIMITED). The Initial Screen will prompt you to enter the file name of the database you are to append/copy the data into. At this point, you can either type in the name of the target database, or ... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ └────────────────────────────────────────────────────────────────────────────┘ If it exists in the current directory, press enter on an empty prompt to display all databases to select from. ┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │INVENT.DBF │ 375 │ 09/16/89 │ │ │ │AR.DBF │ 7219 │ 09/16/89 │ │ │ │HISTORY.DBF │ 103 │ 09/16/89 │ │ │ │PERSONS.DBF │ 24271 │ 09/16/89 │ │ │ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ │ │ └───────────────────────────────────────────────────────────────────────────┘ The next prompt will be to select the type of Append: ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ └──────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB Page: 49 If you are appending from another database (.DBF) then select 'Standard'. Select the SDF option if you are appending from a 'flat' ASCII file. Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENTY.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB Page: 50 ■ BROWSE DATABASES Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... The DAYO Inventory indexes are the exception. They are automatically set/used. An example of a browse screen: TJS LAB, PO BOX 585366 ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥───────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨───────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ 51/60 DAYO UPS, TJS LAB Page: 51 To edit a memo field, just highlight the field, and start typing. * * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING! ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ PRICE LIST YOURPART NOTES │ │───────────────────────╥────────────╥─────────────────╥─────────────────────│ │ 896.16 ║ 1792.32 ║ ║ <Memo> │ │ 1064.19 ║ 2128.38 ║ ║ <Memo> │ │ 672.12 ║ 1344.24 ║ ║ <Memo> │ │ 1736.31 ║ 3472.62 ║ ║ <Memo> │ │ 504.09 ║ 1008.18 ║ ║ <Memo> │ │ 784.14 ║ 1568.28 ║ ║ <Memo> │ │ 1400.25 ║ 2800.50 ║ ║ <Memo> │ ┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐ │You can edit memo fields too... │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ Special keys for 'moving around' the BROWSE screen are: Left Arrow Key - Move to next field to your left Right Arrow Key - Move to next field to your right Ctrl Home - Go to the leftmost field Ctrl End - Go to the rightmost field (on the end of the record) Up Arrow - Move highlight to the previous record Down Arrow - Move highlight to the next record PgUp - Page up a full screen of records PgDn - Page down a full screen of records Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end or last record of the file Ctrl N - Add a record (where applicable) Ctrl U - Delete a record (where applicable) F5 - To seek/find a record based upon the active index Esc - Exit the current operation Remember that there are many more fields to the right of the screen. Press the right arrow key to view them... DAYO UPS, TJS LAB Page: 52 ■ COPY (.DBF) TO Copy records to another (new) database. Use this option to copy select records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can also be used to create backups of data (EG: copy to floppy). ┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │HARPS.DBF │ 375 │ 09/16/89 │ │ │ │INVENT.DBF │ 7335 │ 09/16/89 │ │ │ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │ │ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │ │ │AP.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ The next prompt will be to select the type of COPY TO option you want: ┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: INVENT.DBF │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ │ │ Copy Records From INVENT.DBF │ └────────────────────────────────────────────────────────────────────────────┘ The Standard option is simply creating another database (.DBF). The SDF and DELIMITED options will create ASCII files. The STRUCTURE option creates a new database with the same file structure as the initial database (no records copied). DAYO UPS, TJS LAB Page: 53 The next prompt (optional), requires some knowledge of dBase (tm). This prompt is requesting the user to enter a condition or filter. If all records are to be copied, just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as shown next) is fine... ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB Page: 54 The following window message will appear while the COPY TO routine does its task: ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW10 │ │ │ │ Enter Condition: PRICE>0 │ │ Sample cond┌───────────────────────────────────────────────┐ │ │ │┌─────────────────────────────────────────────┐│ │ │ CONDITION: ││┌───────────────────────────────────────────┐││ │ │ │││┌─────────────────────────────────────────┐│││ │ │ ││││Hold those camels while I do this COPY TO││││ │ │ │││└─────────────────────────────────────────┘│││ │ │ ││└───────────────────────────────────────────┘││ │ │ │└─────────────────────────────────────────────┘│ │ │ └───────────────────────────────────────────────┘ │ │ Copy Records From SDF To NEW10 │ └────────────────────────────────────────────────────────────────────────────┘ ■ CREATE DATABASE Create a new database. This routine lets you create entirely new database structures. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ ║ ║ 0 ║ 0 │ │ ║ ║ ║ │ │ ║ ║ ║ │ ┌─────────────│ ║ ║ ║ │────────────┐ │ │ ║ ║ ║ │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO UPS, TJS LAB Page: 55 * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING... *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO UPS, TJS LAB Page: 56 ■ DELETE RECORDS Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └────────────────────────────────────────────────────────────────────────────┘ After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ The number of records deleted will be displayed upon the screen as depicted just above... DAYO UPS, TJS LAB Page: 57 ■ ERASE FILE Erase a file (forever!). Use this option with extreme care! Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY REMOVED FROM EXISTENCE NO SECOND CHANCES HERE... The first prompt is for the file name. You can press enter on an empty prompt to bring up a window selection of all files in the current directory. ┌────────────────────────┐ ┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘ │BKDOOR.DOC │ 37029 │ 09/17/89 │ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │D.DBF │ 259 │ 09/16/89 │ │D.DBT │ 512 │ 09/16/89 │ │DAYOBK.BAK │ 36879 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ │DAYOBK.OBJ │ 35585 │ 09/16/89 │ │DAYOCAL.MAP │ 35 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │DDD.DBT │ 512 │ 09/16/89 │ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More To ERASE a file, just highlight it, then press Enter... ■ EXIT TO DOS This option will close all open files and databases and exit to DOS without having to return to the main menu exit routine. DAYO UPS, TJS LAB Page: 58 ■ INDEX A DATABASE You will be prompted to select the database you wish to index. After selecting the database, by typing in the name or pressing Enter on an empty prompt (then selecting from the window), you will be given a listing of all fields in that database atop the screen. ┌────────[ PICK A DATABASE ]───────────┐. │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DAD.DBF │ 259 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SPW.DBF │ 7335 │ 09/16/89 │ │SOW.DBF │ 103 │ 09/16/89 │ │BOY.DBF │ 24387 │ 09/17/89 │ │SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ You will now be prompted to enter the name of the Index File. It will be (by default), named exactly the same as the selected database, with the exception of the extension. This will default to .NDX or .NTX depending on whether you linked NDX.OBJ with your application. *** Remember that the BROWSE routine only looks at indexes with the same name as the database. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ └───────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB Page: 59 At the prompt for the index key, enter a field name, or a valid dBase/Clipper expression. ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ │ Enter the Key Expression: PART+MFG_PART │ └───────────────────────────────────────────────────────────────┘ ■ LIST FIELDS List fields to screen or printer. This routine is a great tool for providing simple reports and lists. The first prompt will be for the database you wish to work with. Type the name of the file, or press Enter on an empty prompt to bring up a window of all databases in the current directory for selection. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │INVEND.DBF │ 259 │ 09/16/89 │ │INVENT.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SOMEDAY.DBF │ 7335 │ 09/16/89 │ │TANGO.DBF │ 103 │ 09/16/89 │ │AP.DBF │ 24387 │ 09/17/89 │ │BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB Page: 60 The next prompt is for a condition or filter. This makes it possible to list only specific records that meet that condition you enter. The condition must be a valid dBase/Clipper expression, or none (to list all). ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌─────────────────────────────────────────────────────┐ │ Enter Filter: │ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ └─────────────────────────────────────────────────────┘ ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: │ │ │ └───────────────────────────────────────────────────────────────┘ A window box appears next displaying all the fields in the selected database and an option to list all fields. Highlight any combination of fields ( or ALL) that you want listed. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║ ├─────────────────┤ ║ ╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝ │RECNO() │ │MFG_PART │ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB Page: 61 The fields you select will be displayed at center top of screen. Press Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │DESC┌──────────────────────────────────────────────────────────────────┐ │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │ │LIST│ │ │YOUR└──────────────────────────────────────────────────────────────────┘─┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB Page: 62 The list is very simple, and if displayed onto the screen, may look like the following: PART MFG_PART PRICE 4523 0.00 DAYO9S 41926 1904.34 DAYO10S 13564 616.11 DAYOCOMP 45625 2072.37 DAYOALLS 43159 1960.35 INDEXER 50558 2296.41 INDEXERS 51791 2352.42 5 DEMO 4932 224.04 DAYO13S 20963 952.17 MENUS 53024 2408.43 OFFSITEP 56724 2576.46 ONSITEP 57957 2632.47 DAYO2S 24662 1120.20 DAYO9 40693 1848.33 DAYO10 12331 560.10 DAYOCAL$ 44392 2016.36 DAYO13 19730 896.16 DAYO2 23429 1064.19 DAYO11 14797 672.12 DAYO8 38227 1736.31 DAYO1 11098 504.09 DAYO12 17264 784.14 DAYO5 30828 1400.25 ......PRESS ANY KEY TO CONTINUE...... ■ MODIFY DATABASE Change the fields/structure of a database. You can add new fields, delete fields, change the length and type of field in any of the databases. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ******************************************************** *** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST *** *** IT IS SLIGHTLY BOTHERSOME SORRY! *** ******************************************************** *** If any error is made in this routine, you will experience an error, either immediately, or when you start to access the database. This error may even cause your computer to hang! DAYO UPS, TJS LAB Page: 63 *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ■ PACK DATABASE Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB Page: 64 ■ RECALL RECORDS Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ■ RETURN TO MENU Returns to the procedure that called MISC Routines. ■ RUN (DOS COMMAND) Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ Press and Enter: EXIT to return to your Clipper Application. EG: The COMPAQ Personal Computer MS-DOS Version 3.31 (C) Copyright Compaq Computer Corp. 1982, 1987 (C) Copyright Microsoft Corp. 1981, 1987 C:\KISBBS>EXIT DAYO UPS, TJS LAB Page: 65 ■ SIMPLE EDITOR A simple editor and word processor. Use this option to create and read simple TEXT files. File size is limited to your machines capabilities or 32,000k. The first prompt is for the name of the file you wish to edit. Type in the name, or press Enter on an empty prompt to bring up a window option box containing all files in the current directory. ┌────────────────────────┐ ┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ ┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐ │ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │ │ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │ └────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ │DEMO.MAP │ 7780 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...), so be careful at what you select for viewing/editing. If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those changes. If you exit with an Esc, all changes will be lost! ┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐ │CLIPPER demo │ │CLIPPER MISC │ │KWAIT 10 │ │LIB MISC-+MISC,MISC.LST,MISC │ │KWAIT 10 │ │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │ │KWAIT 10 │ │DEMO │ └────────────────────────────────────────────────────────────────────────────┘ Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0 DAYO UPS, TJS LAB Page: 66 Special keys for 'moving around' the SIMPLE EDITOR screen are: Left Arrow Key - Move to your left Right Arrow Key - Move to your right Ctrl Home - Go to the top, leftmost corner of window Ctrl End - Go to the bottom, rightmost corner of window Up Arrow - Move up one line Down Arrow - Move down one line PgUp - Page up a full screen PgDn - Page down a full screen Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end of the file * F2 - Import text from a text file * Ctrl W - Save Changes and Exit * Esc - ABORT Changes and Exit The margin may exceed the boundaries on the right side of the screen, but the text is easily accessed using the special keys above... ■ SORT DATABASE This option takes a database, sorts it, and copies the result into a new database. The first prompt is for the name of the database you want to sort. Enter the name, or press Enter on an empty prompt to bring up a window box containing all databases in the current directory. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DOG.DBF │ 259 │ 09/16/89 │ │CAT.DBF │ 375 │ 09/16/89 │ │CAR.DBF │ 195 │ 09/17/89 │ │BAM.DBF │ 7335 │ 09/16/89 │ │HARP.DBF │ 103 │ 09/17/89 │ │TRAIN.DBF │ 24387 │ 09/17/89 │ │HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └───────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB Page: 67 The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ The next prompt is for the sort field (limited to 1 field)... ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ■ TYPE (PRINT) FILE Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB Page: 68 The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... ■ ZAP DATABASE Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. DAYO UPS, TJS LAB Page: 69 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB, INC. Page: 70 ■ HELP SCREENS While in the browse screens, some of the option windows, and in the SIMPLE EDITOR, pressing the F1 key, will display a help screen. BROWSE help: ┌──────────────────────[ DAYOUPS HELP: DBEDIT, 0, ]─────────────────────────┐ │ │ │- Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ └────────────────────────────────────────────────────────────────────────────┘ Option Box Help: ┌───────────────────────[ DAYOUPS HELP: ACHOICE, 0, ]───────────────────────┐ │ │ │ │ │ │ │ │ │ - Special keys for 'moving around' the Option Box are: │ │ │ │ Up Arrow - Move up one option │ │ Down Arrow - Move down one option │ │ PgUp - Page up multiple records │ │ PgDn - Page down multiple records │ │ Esc - ABORT and Exit │ │ │ │ │ │ After highlighting the option you desire, press Enter... │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO UPS, TJS LAB Page: 71 Editor help: ┌──────────────────────[ DAYOUPS HELP: MEMOEDIT, 0, ]───────────────────────┐ │ │ │ - Special keys for 'moving around' the EDITOR screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the top, leftmost corner of window │ │ Ctrl End - Go to the bottom, rightmost corner of window │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end of the file │ │ Ctrl W - SAVE Changes and Exit │ │ Esc - ABORT Changes and Exit │ │ F2 - Import another text file into your document │ │ │ │ The margin may exceed the boundaries on the right side of the screen, │ │ but the text is easily accessed using the special keys above... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ EXPANDED HELP After Version 1.3, expanded help routines were added to all DAYO modules. At almost all prompts and menus you can press F1 for help. Help can be a function key message as displayed on the previous page, a message that you have created (user defined & inputted), or the ability to read the documentation on the screen. DAYO UPS, TJS LAB Page: 72 ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES If you press F1 and no user defined & inputted message exists for that section of the program you are currently in you will receive a message to this effect, and then a blank/empty screen. The editing keys for this option are the same as for the Simple Editor (previous page). DAYO UPS Version 4.00 TJS LAB ┌───[February 1992]──┐ ┌──────[ DAYO HELP Called by Program: DAYOUPS Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ ╔════════════════════════════════════════════════════════╗ │ │ ║ No Online Help Messages Exist for this prompt... ║ │ │ ║ ║ │ │ ║ You can type in any help message you wish, or ║ │ │ ║ press F1 to view the document for DAYOUPS. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ Press any key to continue... ║ │ │ ╚════════════════════════════════════════════════════════╝ │ │ │ │ │ ├───────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │ └───────────────────────────────────────────────────────────────────────────┘ If you wish to input anything at this point, just type whatever you wish, remembering to press Ctrl W to save all changes. Pressing Esc will not save ANY changes ( all effort you put into writing a help message will be lost! ). DAYO UPS, TJS LAB Page: 73 DAYO UPS Version 4.00 TJS LAB ┌───[February 1992]──┐ ┌───────[ DAYO HELP Called by Program: DAYOUPS Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW DOCUMENTATION ONSCREEN To view the documentation for the module you are in, it must first exist in the current directory. Document files are named the same as the module, and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOUPS.DOC, DAYOPAY.DOC. Press F1 in the User Defined & Inputted Help Message screen to display the document (user manual). The special keys in this option are displayed in the Help Screen (press F1 again) for this option: ╔══════════════════════════════════════════════════════════════════════════╗ ║ While viewing the document for DAYOUPS the keyboard is configured ║ ║ as followed: ║ ║ ║ ║ Esc Exit ║ ║ F5 Find a string. This search is not case sensitive ║ ║ Examples: PAGE 50 ║ ║ INTRODUCTION ║ ║ REPORTS ║ ║ Home Return to the beginning of the document ║ ║ End Go to the bottom of the document ║ ║ PgUp Page up ║ ║ ║ ║ Any other key moves acts like PgDn (page down) ║ ║ ║ ║ Press any key to continue... ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO UPS, TJS LAB Page: 74 ■ DATABASE LISTING UPSTEMP.DBF Todays/current manifest records UPS.DBF History of manifest records UPSPOST.DBF Temporary database used by UPS program PDRIVER.DBF Printer codes used with 'Printer Setup' UPSZONE.DBF Local Zone Chart for your specific area UPSTABLE.DBF Regular/standard ground rates UPSTRAC.DBF Ground Trac rates ZONECGAR.DBF Ground zones to Canada for Arkansas ZONECGAZ.DBF Ground zones to Canada for Arizona ZONECGCA.DBF Ground zones to Canada for California ZONECGCN.DBF Ground zones to Canada for Connecticut ZONECGFL.DBF Ground zones to Canada for Florida ZONECGID.DBF Ground zones to Canada for Idaho ZONECGIO.DBF Ground zones to Canada for Iowa ZONECGMT.DBF Ground zones to Canada for Montana ZONECGNE.DBF Ground zones to Canada for Nebraska ZONECGTX.DBF Ground zones to Canada for Texas ZONEAIR.DBF Air zones to Canada for all states UPSAIR.DBF Air rates to Canada for all states UPSGRO.DBF Ground rates to Canada for all states CANADAZ.DBF Canadian rates ZONEIAK.DBF International zones for Alaska ZONEIAL.DBF International zones for Alabama ZONEIAZ.DBF International zones for Arizona ZONEIMIA.DBF International zones for Miami EXPEDAK.DBF Overseas Expedited air rates for Alaska EXPEDAL.DBF Overseas Expedited air rates for Alabama EXPEDAZ.DBF Overseas Expedited air rates for Arizona EXPEDMIA.DBF Overseas Expedited air rates for Miami EXPRSAK.DBF Overseas Express air rates for Alaska EXPRSAL.DBF Overseas Express air rates for Alabama EXPRSAZ.DBF Overseas Express air rates for Arizona EXPRSMIA.DBF Overseas Express air rates for Miami DAYO UPS, TJS LAB Page: 75 ■ TJS 'Computer' LAB TJS LAB is an association of programmers and technicians that produce customized, multiuser software for the PC based network (ie: Novell and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and Accounting (A/R, A/P). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are inexpensive! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Custom/contract programming, by TJS LAB, and our associates is available. Standard rate is $50.00 per hour (our sites). Guaranteed quality and timely work is our number one policy. We make program enhancements/changes/fixes at our location(s), but can/do make 'house calls' via special software and a modem. Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858-5366 Or call us (8:00 am - 11:00 pm): (407) 291-3960 * Note that TJS LAB, nor any of the associates accept/take any support calls for unregistered products.